package cn.yuanqiao.archive.appManager.mapper;/**
 * @author 赵常飞
 * @date 2024/1/25 16:08
 */

import cn.yuanqiao.archive.appManager.domain.TenantGdfwAndBgqx;
import cn.yuanqiao.archive.appManager.domain.TenantGdfwAndBgqxRule;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *@Author: 赵常飞
 *@Date: 2024/1/25 16:08
 *@Description:
 *@Note:
 */

public interface TenantGdfwAndBgqxMapper {
    List<TenantGdfwAndBgqx> getTreeListfirst(@Param("tableName") String tableName,@Param("categoryId")Long categoryId);

    List<TenantGdfwAndBgqx> getchildrens(@Param("id") Long id,@Param("tableName") String tableName,@Param("categoryId")Long categoryId);

    Integer addzd(TenantGdfwAndBgqx gdfwAndBgqx);

    Integer editzd(TenantGdfwAndBgqx gdfwAndBgqx);

    List<TenantGdfwAndBgqx> gettable(@Param("parentId")Long parentId,@Param("tableName")String tableName,@Param("categoryId")Long categoryId);

    Integer addtj(TenantGdfwAndBgqxRule gdfwAndBgqxrule);

    Integer edittj(TenantGdfwAndBgqxRule gdfwAndBgqxrule);

    List<Map<String,Object>> gettjtable(@Param("zdId")Long zdId,@Param("tableName1")String tableName1,@Param("tableName2")String tableName2,@Param("tableName3")String tableName3,@Param("tableName4")String tableName4,@Param("type")Integer type);

    void creatTabelgdfwandbgqx(@Param("tableName")String tableName);

    void creatTabelgdfwandbgqxRule(@Param("tableName")String tableName);

    void creatTabelmdatalistshy(@Param("tableName")String tableName);

    List<TenantGdfwAndBgqx> getgdfwandbgqx(@Param("categoryId")Long categoryId);

    List<TenantGdfwAndBgqxRule> getgdfwandbgqxrule(@Param("id")Long id);

    TenantGdfwAndBgqx getzd(@Param("zdid")Long zdid,@Param("tableName") String tableName);

    int delete(@Param("tableName")String tableName,@Param("tjid") Long tjid);

    List<String> getfieldbycategoryid(@Param("tableName1")String tableName1,@Param("tableName2") String tableName2,@Param("categoryId") Long categoryId,@Param("type") Integer type);


    List<TenantGdfwAndBgqx> getzdlist(@Param("tableName")String tableName,@Param("categoryId") Long categoryId);

    Integer getcount(@Param("sql")String sql);

    String getbgqxnames(@Param("tableName")String tableName, @Param("bgqxlist")List<String> bgqxlist);

    void updatemdataid(@Param("shyTable")String shyTable,@Param("dataListTable") String dataListTable);
}
